I need to join 3 tables (superseller, adexmart and generictable) and fetch following fields from above 3 tables:

1. url, price from table superseller, and
2. url, amount from table adexmart where
3. pid='somevale' from generictable

a. superseller table
url, price, id (fields)
b. adexmart table
url, mount, id (fields)
c. generictable table
pid, aid(reference from adexmart table), sid(reference from superseller table)

Recommended Answers

What do you have so far ?

Jump to Post

All 3 Replies

What do you have so far ?

What do you have so far ?

I did not do anything, I am week in database joining and unable to write query..

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.