extract information on 4 table

[garmoska89]

--select produse.model, produse.producator , produse.tip, max(pret) as pret_minim from produse,
select produse.model,produse.producator,produse.tip,pret from produse,
(
select model,pret from imprimante where pret=(select MAX(pret) from imprimante)
union
select model,pret from laptop_uri where pret=(select MAX(pret) from laptop_uri)
union
select model,pret from pc_uri where pret=(select MAX(pret) from pc_uri))as s2 where produse.model=s2.model
my answer is:
1233 A PC 980
1276 A imprimante 400
1288 A imprimante 400
1750 B Laptop_uri 1200


NOOOOO!! i need answer: 1 result: 1750 B Laptop_uri 1200
how i do i do

 

[garmoska89]

i need max(pret) from s2

 

[gmmastros]

try:

select [!]Top 1[/!] produse.model,produse.producator,produse.tip,pret from produse,
(
select model,pret from imprimante where pret=(select MAX(pret) from imprimante)
union
select model,pret from laptop_uri where pret=(select MAX(pret) from laptop_uri) 
union
select model,pret from pc_uri where pret=(select MAX(pret) from pc_uri))as s2 where produse.model=s2.model
[!]Order By s2.pret DESC[/!]

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[garmoska89]

no i need use function max()
if I use only max(pret) its ork
result:id=1 max_pret=1200
no i need use max function on 2 table on thhe moment s2 and produse
do you know?

 

[garmoska89]

daca vorbiti romana spunetimi

 

[sabinUE]

George respons should do the work.
Did you try it?

It's ok? Este in regula ?Sabin