nested queries help

Hi everyone, I'm new here. 🙂

I'm trying to wrap my head around nested queries. Here is my setup...

I have 2 tables in which I do a SELECT from with the following query:

SELECT * FROM `list_name`, `list_items` WHERE [B]list_name.id[/B] = 'xx' AND [B]list_items.list_name_id[/B] = 'xx'

list_name.id = primary id on list_name;
list_items.list_name_id = foriegn key to connect to list_name;

TABLE list_name only returns one result, the name of the list.
TABLE list_items returns multiple items.

I'm fairly new to MySQL, is there a better way to perform this query on two tables? such as using a nested query?

Thanks in advance.

Hi there,

It's not really clear what you're actually trying to achieve, so I'll hazard a guess.

It seems that what you might want are JOINs. For example ...

SELECT * 
FROM `list_items` 
LEFT JOIN `list_name` ON (`list_items`.`list_name_id` = `list_name`.`id`)
WHERE `list_name`.`id` = 'xx'

This would give you a full list of items whilst including the name from the JOINed table.

Might not be exactly what you're after, but could get you on your way.

Paul.

yes, that's exactly what I was shooting for! Sorry for not being clear. Thank you! 😃