How to select sql query for two table with multiple values in php

Question

I have two tables in my SQL Server database. The first is bidder_interest_name and second is tender_type_subcat . There have multiple value column bidder_interest_subcategory in bidder_interest_name and tender_type_subcategory in tender_type_subcat tables.

Now I want to select the multiple values from both the tables for a particular subcategory and need to both table minimum matching value.

This is what I'm doing

What I have tried:

SELECT bi.bidder_interest_subcategory,tt.tender_type_subcategory 
FROM bidder_interest_list as bi,new_tender_two as tt 
WHERE bi.bidder_id=$bidder_id

SELECT bi.bidder_interest_subcategory,tt.tender_type_subcategory FROM bidder_interest_list as bi,new_tender_two as tt WHERE bi.bidder_id=$bidder_id Don't work — illeas, May 10 '16 at 06:49
Do the tables relate (to one another) in some way? And note that SQL server is not MySQL — Strawberry, May 10 '16 at 06:59
Possible duplicate of [How can an SQL query return data from multiple tables](http://stackoverflow.com/questions/12475850/how-can-an-sql-query-return-data-from-multiple-tables) — Aurasphere, May 10 '16 at 07:06

score 1 · Accepted Answer · answered May 10 '16 at 06:56

1

Try this

SELECT bi.bidder_id, bi.bidder_interest_subcategory,tt.tender_type_subcategory FROM bidder_interest_list as bi,new_tender_two as tt WHERE bi.bidder_id=$bidder_id;

answered May 10 '16 at 06:56

AssenKhan

576
5
15

yes but i have two table same value i check this var_dump but output is NULL – illeas May 10 '16 at 07:16

score 0 · Answer 2 · 2016-12-29T10:08:28.997

0

Try this :SELECT bi.bidder_id=tt.tender_id, bi.bidder_interest_subcategory,tt.tender_type_subcategory FROM bidder_interest_list as bi,new_tender_two as tt WHERE bi.bidder_id=bidder_id;

edited Dec 29 '16 at 10:08

answered Dec 29 '16 at 10:01

How to select sql query for two table with multiple values in php

2 Answers2