Recent content by johnbest5673

hi all Actually What I need is a MINUS query... which will give me the dates which are not available in another table.. simpplyy... working on sql after a gap of 7-8 yrs... so forgot the keyword... MINUS.. :D Have a nice day JB

hi i have 2 tables... both having dt as date field... One table contains dates in repeated form while the other table have date entry as a single row.. ie no duplication... I need help on the query which will give me the dates which are not present in the table 1 ie the table which have date...

Thanks dear

Dear friends How could I get top 50 records from a table? have a nice day JB