Page is a not externally linkable
- Code, Content, and Presentation
-- Databases
---- Selecting multiple rows from a single table


neophyte - 1:58 am on Oct 28, 2012 (gmt 0)


Hello brotherhood of LAN -

Thanks for the fast reply.

I tried that select yesterday and I do get results but I only get 2 results (for Kayak - Single), not the 4 results I need (2 for kayak single and 2 for kayak double).

Indeed, I do need to match both... I think it can be solved with a self-join (or by some other means) but, like mentioned previously, I just can't seem to get the syntax correct.


Thread source:: http://www.webmasterworld.com/databases_sql_mysql/4513090.htm
Brought to you by WebmasterWorld: http://www.webmasterworld.com