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.

 

 

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • 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.