This is a discussion on "Adding To and StrQuery = Select" within the Databases section. This forum, and the thread "Adding To and StrQuery = Select are both part of the Program Your Website category.
|
|
|
|
|
 |
||
Adding To and StrQuery = Select
|
||
| Notices |
 |
|
|
LinkBack | Thread Tools |
Aug 15th, 2007, 08:25
|
|||
|
|||
|
Adding To and StrQuery = Select
here is my select
strQuery = "SELECT P_ID, P_Name" & CInt(numLanguageID) & " FROM (tblCactuShop" & TABLE_PREFIX & "RelatedProducts INNER JOIN tblCactuShop" & TABLE_PREFIX & "Products ON tblCactuShop" & TABLE_PREFIX & "RelatedProducts.RP_ChildID = tblCactuShop" & TABLE_PREFIX & "Products.P_ID) LEFT OUTER JOIN tblCactuShop" & TABLE_PREFIX & "Suppliers ON tblCactuShop" & TABLE_PREFIX & "Products.P_SupplierID = tblCactuShop" & TABLE_PREFIX & "Suppliers.SUP_ID WHERE RP_ParentID = " & P_ID & " AND P_Live = 'y' AND P_CustomerGroupID IN (0," & NumSafe(DB_CG_ID) & ") AND (SUP_Live <> 'n' OR SUP_Live IS NULL) AND P_ID NOT IN (" & strProductsDone & ") ORDER BY P_Name" & CInt(numLanguageID) where in that would i add the "V_Price" from the table "Versions" 
|
|
|
|
Aug 16th, 2007, 08:47
|
|||
|
|||
|
Re: Adding To and StrQuery = Select
Wow, that looks confusing!
Give this a go: SELECT P_ID, P_Name, V_Price" & CInt(numLanguageID) & " FROM Versions, (tblCactuShop" &... Is the query you posted working?
|
|
| Tags |
| select |
| Thread Tools | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| chained select box dependable select | thenamenoonehastaken | JavaScript Forum | 0 | Feb 8th, 2008 05:49 |
| CSS and select | djme | Web Page Design | 1 | Mar 2nd, 2006 02:05 |
| Help with select statment | rocket468 | Classic ASP | 4 | Dec 8th, 2005 15:55 |
| Select a row and go! Please help? | taymond | JavaScript Forum | 1 | Nov 16th, 2005 15:50 |
| I need help with the Select Option..... | courtjester | JavaScript Forum | 6 | Nov 19th, 2003 14:34 |
