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)
Jump to PostWhat do you have so far ?
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..
This is quite a basic tutorial to help you get started:
http://www.tizag.com/mysqlTutorial/mysqljoins.php
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.
