Guest milfredo Posted April 17, 2006 Share Posted April 17, 2006 Here is code that I know is wrong. Can some one make this work for me.SELECT Horsename AS NameFROM EQRaces EQChartsWHERE ProjspeedRating > 80horsename comes from EQCharts database and ProjSpeedRating is from EQRacesdatabase.I just can't seem to find anyone to help me. Thanks in advanceMilfred Link to comment Share on other sites More sharing options...
aspnetguy Posted April 18, 2006 Share Posted April 18, 2006 Do you mean 2 different tables??? You be storing all your info in the same datbase, just have several tables. SELECT t1.columnName, t2.columnNameFROM tableName1 t1, tableName2 t2WHERE t1.columnName = t2.columnName Thats the basics of a multi table query. If you post the structure of your 2 tables I can show you the exact query you would need. Link to comment Share on other sites More sharing options...
ray Posted May 5, 2006 Share Posted May 5, 2006 try joining the tables, you'll need common columns in both tables Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now