Member Avatar for abhi10kumar

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)

  • 3 Contributors
  • 3 Replies
  • 98 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by blocblue
Member Avatar for abhi10kumar

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 developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.