Re: Querry giving incorrect result
From: Vishal Parkar (REMOVE_THIS_vgparkar_at_yahoo.co.in)
Date: 04/20/04
- Next message: Retna: "No of columns in a table"
- Previous message: Simon: "Querry giving incorrect result"
- In reply to: Simon: "Querry giving incorrect result"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 20 Apr 2004 08:20:08 +0530
hi simon,
you can do this with the help of INSERT INTO...SELECT syntax.
ex:
insert into baddata (col1,col2,col3)
select col1, col2, col3
from tablea
where not exists
(select * from tableb
where tablea.id = tableb.id)
--
Vishal
vgparkar@yahoo.co.in
- Next message: Retna: "No of columns in a table"
- Previous message: Simon: "Querry giving incorrect result"
- In reply to: Simon: "Querry giving incorrect result"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
- Re: UPDATE query
... > I am struggling to get the syntax right for an UPDATE query with a ...
hence wanting to do an UPDATE query. ... > UPDATE TableA SET ... >
FROM (SELECT FieldA, FieldB from TableB). ... (microsoft.public.access.queries) - Which inner join syntax is more efficent?
... Assuming both TableA and TableB are roughly the same size with index ...
Which syntax will be more efficient? ... TableA AS A INNER JOIN TableB AS B ON A.Col_1
= B.Col_1 ... (microsoft.public.sqlserver.server) - Re: Query problem
... >cant figure out the syntax of the query. ... SELECT tableA.*
... FROM tableA LEFT JOIN tableB ... (microsoft.public.access.formscoding) - Re: Which inner join syntax is more efficent?
... I would look at the execution plan generated by both. ... > Assuming both
TableA and TableB are roughly the same size with index ... Which syntax will
be more efficient? ... (microsoft.public.sqlserver.server) - Re: Cursors (again)
... What does it matter if TableB is temporary? ... or tableA. ...
open cTableB ... (microsoft.public.sqlserver.programming)
