some sql help

[Liviathan]

The new SQL will return the same MIN for every row. So it returns the first row..kinda weird.

 

[brandonbull]

you many want

and(offr_size <> '38500' or offr_size <> '44500')

 

[Liviathan]

I tried that...no idea whats going on there...I guess OFFR_GRADE in the offr_min line is messed up some how.

 

[Jeraden]

I'm not sure what database you are using to get the syntax right, but you need table aliases in there.

offr_min=(select min(offr_prce) from BBOFFER where offr_grade=OFFR_GRADE and offr_size<>42000)

The where clause has offr_grade=OFFR_GRADE. Thats the same field, so thats the same as doing 1=1. Your problem is that the subselect is selecting from bboffer, which is also the main table in the query. Its going to be using offr_grade from the bboffer in the subselect on both sides, as thats whats in scope at that point. I'm assuming you want one of them to come from the bboffer in the main query and one in the subselect, to join on that field.
So you need to do whatever to alias the tables so you can differentiate between the field on the 2 separate tables.
if that makes sense.

offr_min=(select min(b.offr_prce) from BBOFFER B where b.offr_grade=a.OFFR_GRADE and b.offr_size<>42000)

like that, or however you alias them.

 

[brandonbull]

What database software is that?

 

[brandonbull]

offr_min=(select min(b.offr_prce) from BBOFFER B where b.offr_grade=a.OFFR_GRADE and b.offr_size<>'42000')

Missing single ticks around 42000