Welcome Guest, Not a member yet? Register   Sign In
A query in multiple tables
#5

[eluser]earlyriser[/eluser]
ray73864: I used your approach and I got:
Error Number: 1109
Unknown table 'c' in field list
SELECT w.name, c.rating FROM (`wines` w) JOIN `wine_comments` wc ON w.id = wc.wine_id WHERE `user_id` = '2'

I wonder what w, c and wc does mean.

Thanks


Messages In This Thread
A query in multiple tables - by El Forum - 10-01-2008, 02:33 PM
A query in multiple tables - by El Forum - 10-01-2008, 04:33 PM
A query in multiple tables - by El Forum - 10-01-2008, 05:17 PM
A query in multiple tables - by El Forum - 10-01-2008, 05:38 PM
A query in multiple tables - by El Forum - 10-01-2008, 05:52 PM
A query in multiple tables - by El Forum - 10-01-2008, 08:42 PM
A query in multiple tables - by El Forum - 10-01-2008, 08:58 PM
A query in multiple tables - by El Forum - 10-01-2008, 09:16 PM



Theme © iAndrew 2016 - Forum software by © MyBB