Using 2 + tables in SQL

[cheyner11]

I need to use two different tables to bring information in on one page.

My code is currently:

SELECT * FROM nyse,venture WHERE industry='Precious Metals';

This code works when only one table is being used, but will not work when I add the second.

Any help on how I would re-write my "FROM" command to include both nyse and venture.

Thanks

[LordShryku]

What "doesn't work"?
Does it not return anything?
Does it have an error?
Do the tables join?
Is the field "industry" in both of the tables?
What are you trying to accomplish?

[cheyner11]

It will not query the database. When using only one table this code works fine, but when I add two tables the query comes up with an error.

Both stock market tables contain the industry field. And I need to select Companies in the precious metals industry form two seperate stock exchange tables. TSX Venture being one, and TSX. I use two tables because the same comapnies can be listed on two different exchanges and use the same symbol in each. And I use symbol as my primary field.

YOur help is greatly appreciated.

[xlordt]

an error would be good to see 🙂

[robinjohn]

how about:

SELECT * FROM nyse,venture WHERE ((nyse.industry='Precious Metals') AND (venture.industry = 'Precious Metals');