How to use 2 select query in single query
Oracle:I have a select query with group by and where conditions.
select Date,Name,count(*)Total from TableName where dt=getdate() group by Date,Name
Date Name Total
Aug12 abc 150
Now Im trying to bring out another select query with same where conditions but one condition extra
Date Name Total Price
Aug12 abc 150 45
select Date,Name,count(*)Total,(select Price1 from TableName where dt=getdate() and status=true ) from TableName dt=getdate() group by Date,Name
Instead of this subquery any way to use join