SELECT multiple tables

[Anon]

I am sure that I am complicating this much more than necessary but I am still unable to pull the same exact field from 2 different tables. Can someone please help me with this. Here is what I have so far:

SELECT * FROM table_a, table_b WHERE title LIKE '$title%' ORDER BY title

What am I doing wrong?

Thanks in advance.

[neuromancer]

SELECT n,... FROM table_a INNER JOIN table_b ON table_a.title=table_b.title WHERE table_a.title = '??????' ORDER BY title

This isn't usually how tables are setup, Tables A and B have primary keys I would think and they are the best thing to join on.

SELECT n,... FROM Customers INNER JOIN Bills ON Customers.CustomerID = Bills.CustomerID WHERE Customers.CustomerID = n

[Anon]

Hi Will, When you say you pull same exact fields there should be a relationship between them, for example if table_a has this fields title, ida, where id is the primary key of table_a, then table_b, for it to relate with table_a will have to have fields like title, idb, ida, where idb is the primary key of table_b, and ida is the foreign key since it's the one we will use to relate the two tables so in your select query you will have something like

Select * from table_a a, table_b b, where b.ida = a.id order by title;

I hope this will help
Cheers