Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

MS Access Query Help

Comment:

I have in a Table1 the Business Name Address and phone number and i Table2 i have only a phone number I want to delete into the table1 which is in the table2. Pls reply me I need it urgently. thanks in advanced

Reply:

delete from table1 where phone_number in (select phone_number from table2);

0

Visio and oracle database

Please I need Help

Summary: I have created an MS Access db, 2 of the fields relate to time...StartTime & EndTime. From this I have created a query to display the attendance time ([EndTime]-[StartTime])*24 which gives me the dif...

Summary: Hi, I'm trying to run a query similar to the following: Select category, count(distinct names) from tableA AA inner join tableB as BB on AA.ctr#=bb.ctr# where aa.datecol > 1/1/2008 and bb.type='yes' ...

Summary: Hello, I have created a database in MS Access that has multiple forms in order to help my co-workers enter "invoices" for our customers and to keep up with information. There are 4 computers in our of...