| |
| |
| |
|
Comments:
<0> hi, how can I copy one row into another in one table ?
<1> with an insert statement
<1> insert t1 (f1,f2) select f3,f4 from t2 where x=y
<0> insert into tableA (field2) select * from field1 does that work to ?
<1> what do you want to do, copy a column?
<0> yes
<0> insert into tableA (field2) select field1 from tableA I meant
<1> that copies a row
<0> INSERT INTO Maintable (Category) SELECT ID FROM Maintable did not work
<1> im lost, you have f1,f2 in t1 and you want to make f2=f1 ?
<0> yes
<1> update t1 set f2=f1 :)
<0> where f1 does not change, right ?
<1> yes
<0> o thx
<0> ok thx
<2> hello
<2> INSERT INTO KarticaTemp IN '" & App.Path & "\sys2.mdb' SELECT id as IDa,Name,Price from Table1
<2> I use that to bulk copy data to another table
<2> now i need to get Price from another table for that ID, and then to insert
<2> is there any way i can select it in that query above
<2> ...
<3> DELETE FROM RMACGroup WHERE FK_RSiteID = (SELECT PK_ID FROM deleted)
<3> Does that look correct for a DELETE trigger?
<3> As in, it would delete all entries from RMACGroup, for which FK_RSiteID is equal to the PK_ID for the deleted record
<4> hI, I am looking for a talented freelance worker in the fields of writing and editing, photography, web design, graphic arts, or computer programming. I am not a bot , i am a real person, if you are interested please send me a personal message or visit my blog at http://freelance-job.blogspot.com
<5> is there a way to do a query on 2 different databases? i have a staff database and different programs that will all need to use this but want to add it to some queries like staff_id
Return to
#sql
or
Go to some related
logs:
indian pizza receipe
#india
#kl
kalki-drama
#india
#allnitecafe
#linux
lookingforfrend
#allnitecafe
#kl
|
|