Jump to content

Getting data from three tables with matching field names


KingOfHeart

Recommended Posts

I have three tables.

Forum_ID, Forum_Info, and Account

BTW, these are not the actual names, but it will do for answering my question.

 

I want to do a search for Forum_ID.

Then when it finds the row in Forum_ID, I want it to list the data.

The Forum_Info has most of the info I need, but some of the fields match with Forum_ID.

In Forum_Info it has the account's ID. The username would have to be read from Account.

 

Now I could do one while loop search, and slap the other two tables within the search, but I'd rather do one search line.

Get what I'm saying?

No, I can not change the fields or tables.

 

 

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.