I'm not familiar with the exact format Drupal uses, how do I add "distinct bw.url" to this query?

$query = "SELECT nr.body, n.*, bw.url

I've tried these and I get errors:

$query = "SELECT nr.body, n.*, distinct bw.url $query = "SELECT nr.body, n.*, {distinct bw.url}

Comments

ThePiston’s picture

ok, so i can't just select distinct of one of them? i guess it wouldn't matter if they were all distinct

ThePiston’s picture

ok - confirmed - putting it in front fixed problem and no errors - thanks