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
– illeas, Commented May 10, 2016 at 6:49
Do the tables relate (to one another) in some way? And note that SQL server is not MySQL — Strawberry
– Strawberry, Commented May 10, 2016 at 6:59
Possible duplicate of How can an SQL query return data from multiple tables — Aurasphere
– Aurasphere, Commented May 10, 2016 at 7:06

AssenKhan · Accepted Answer · 2016-05-10 06:56:14Z

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, 2016 at 6:56

AssenKhan

5665 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

illeas Over a year ago

yes but i have two table same value i check this var_dump but output is NULL

score 0 · Accepted Answer · 2016-12-29 10:08:28Z

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, 2016 at 10:08

answered Dec 29, 2016 at 10:01

user5805421

Collectives™ on Stack Overflow

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

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related