CODEWITHSUNDEEP
sql
arun mohan
arun mohan

Reputation: 45

Select Item number from Sql Table

I I have Two tables in sql

1.inventtable(itemnumber)
2.etext(itemnumber,Rkey,Rval,Lang,id,text)

I want to select the Itemnumber from inventtable where thw itemnumber same as in etext table and the itemnumber in etext table contain Rkey=1,rval=1,id=2).How to achive this?

Upvotes: 0

Views: 429

Answers (3)

Farzad Fallah
Farzad Fallah

Reputation: 601

Try this:

select i.itemnumber
from inventtable i 
join etext e on i.itemnumber = e.itemnumber
where e.Rkey = 1 and e.rval =1 and e.id =2

Upvotes: 3

Masoomian
Masoomian

Reputation: 752

Select itemnumber From  inventtable
Where inventtable in (Select itemnumber From  etext Where  Rkey=1 AND rval=1  AND id=2 )

Upvotes: 0

bsmoo
bsmoo

Reputation: 1059

select i.itemnumber 
from inventtable i inner join etext e     
on i.itemnumber = e.itemnumber
where e.Rkey = 1 
and e.rval =1 
and e.id =2

Upvotes: 0

Related Questions