Jump to content

accessing two databases in one query


Guest milfredo

Recommended Posts

Guest milfredo

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

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

  • 3 weeks later...

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...