i have one complecated sql quert please help me in that
the situation is like this i have one table like
bill(table name)id,date,status in that status
is always 1 or 0 and
other table like
billdetail(table name)
id,bill_id(fk of first table),itm_id(fk of third table),amount
other table is
itm(table name)
id,name
now i want to create one quert that can give me
name of item’s sales in between two date which i give monthwise and whose bill status is one
so please help me in this
id
