Ask a Question related to Coldfusion Database Access, Design and Development.
-
Rustywater #1
How to select record on one table but not the other
Hi,
I have two tables that share a userid in common. I want to select record from
table1 that are not on table2 and each record on table1 should only be returned
once.
What would be the select query to achieve this with MS Access 2003?
thanks
Rustywater Guest
-
How can i retrieve record ONLY From 300 - 400 in amillion Record Table?
HI all Thanks for your time.. I have a question here.. How can i retrieve record ONLY From XXX - XXX in a million Record Table? eg. I have a... -
MS Access SQL: duplicate record... ?SELECT INTO....?
What syntax would you use to dupe a record? Thanks! -- Scotter -
Select and delete unused symbols won't record in an action
The selection and deletion of unused brushes, styles, and swatches from the palettes in a document record properly in an action. (For some reason the... -
Pop-up list to select a record?
What's the easiest way to create a pop-up list so that when the user chooses an item from it it displays that record (and the page then returns... -
move record from 1 table to another table
how can i move info from 1 table to another? I have a table with a form. The table and the form are called customer. I want to move selected... -
Dan Bracuk #2 Re: How to select record on one table but not the other
select distinct some fields
from some tables including table1
where some conditions are met
and table1.userid not in
(select userid from table2)
Dan Bracuk Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
