Ask a Question related to Coldfusion - Advanced Techniques, Design and Development.
-
EdmondsM #1
Sub-Select vs. Join
Hi All, I have two tables. One table holds a list of states names. The other
table holds the statesID the user slected along with there employeeID. I would
like to have a link that allows the user to add additional states to there page
at any given time. Once the user clicks the link, the goal is not to display
to the user the states that he or she as already but only display the remaining
available states to be select. I am thinking that a sub-select would be the
best approach.
Thanks in advance.
EdmondsM Guest
-
Select, Join & field values - 2 tables
I had originally posted this in alt.comp.databases.mysql with no replies (I thought I had posted it here, my bad). Hopefully one of you bright... -
Union or Join or Nested Select - Can't Remember
Its been along time since I have had to write tsql from the hip so any help would be greatly valued. I have a table that contains Country, State,... -
trying to update a table after making a join select query on two tables
here is my problem distilled down I need to be able to change the title of a book associated with an author there are 2 tables "author" and "books"... -
SELECT from multiple tables (not join though)
Hi all, I have another question, I hope it isn't too basic. ^.^ I want to do a select from multiple tables but not join them. What I am trying... -
sub select vs. join
Can anyone help convert the following sub-select into a join of some kind that will return the results described below? SELECT A.RST FROM A...
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
