Need an example to understand how you're suggesting the use NULL or DISTINCT. I've tried using a subquery, but it returns more than 1 result and that is not supported with MySQL.
Here is the subquery idea... SELECT * FROM states WHERE id != (SELECT stateid FROM vlogs GROUP BY stateid) -Matt ----------------------- http://ridertech.com http://leanbackvids.com http://vlogmap.org --- In [email protected], "taoofdavid65" <[EMAIL PROTECTED]> wrote: > > or...select "DISTINCT"? > > > > David > http://www.taoofdavid.com > > --- In [email protected], "LeanBackVids.com" > <[EMAIL PROTECTED]> wrote: > > > > As a supplement to the "Countries of Vlogging" , I've added the > > "States of Vlogging", a breakdown of the North American states and > > provinces. > > > > http://www.vlogmap.org/countries.php > > http://www.vlogmap.org/states.php > > > > It has been a long day and my brain is weak... Any SQL gurus out > > there? I'd like to select all the state_ids from the states table > > that DO NOT appear in the vlog table. The following statement does not > > work, but gives an example of what I'm trying to do... > > > > SELECT states.* FROM states, vlogs WHERE states.state_id != > vlogs.state_id > > > > That last variable needs to represent all the unique state_ids from > > the vlogs table. I'm getting syntax errors all over the place. > > > > It would be cool to list those lonely regions in the vlogosphere. I > > could do the same with countries, but it involves much more data. > > Baby steps. > > > > Hit me back if you can help... > > vlogmap at gmail dot com > > > > -Matt > > ----------------------- > > http://ridertech.com > > http://leanbackvids.com > > http://vlogmap.org > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/KIlPFB/vlQLAA/TtwFAA/lBLqlB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/videoblogging/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
