index | search | no replies | posting guidelines | help

login | register

Index » Products » ASP Report Wizard v2

search this forum:

:: SQL LEFT JOIN :: (8) Post a New Message | Post a Reply
Feb 14 2006, 9:31 AM	SQL LEFT JOIN Post a Reply
aldegn since: Feb 3, 2006 from: United Kingdom	How can I implement this? I have a 2 tables(stocks, variations) that relate to each other through a certain field "stockvariationId" BUT if I join them I only get the records that have got a "stockvariationId" and I would like to list them ALL , with the variation name when appropriate but nothing if they haven't got one not just the ones with stockvariationid<>"". Is that possible with your product? Thanks
Feb 15 2006, 8:36 AM	Re: SQL LEFT JOIN Post a Reply
ghost from: Washington, DC	What kind of database are you using? ------------------------- Ghost
Feb 15 2006, 4:37 PM	Re: SQL LEFT JOIN Post a Reply
aldegn since: Feb 3, 2006 from: United Kingdom	SQL database
Feb 16 2006, 4:03 AM	Re: SQL LEFT JOIN Post a Reply
ghost from: Washington, DC	In the relationship box try this this: stocks.stockvariationId *= variations.stockvariationId means all stocks will be shown. ------------------------- Ghost
Feb 16 2006, 5:01 AM	Re: SQL LEFT JOIN Post a Reply
aldegn since: Feb 3, 2006 from: United Kingdom	Brilliant, this makes this product the best thing since sliced bread! Is there any documentation for little things like this? The manual doesn't go into thorough detail on text replacement and small things like that. ...not that I'm complaining! YOU are the best manual Ghost! Thanks yet again
Feb 27 2006, 1:46 AM	Re: SQL LEFT JOIN Post a Reply
ansareo from: Barcelona	Exist any syntax to do the same using Access Database?
Apr 9 2010, 7:39 AM	Re: SQL LEFT JOIN Post a Reply
johnw9433 since: Aug 24, 2009 from: somewhere	I have this same issue, what would the syntax be for MYSQL? Thank You
Apr 10 2010, 3:51 PM	Re: SQL LEFT JOIN Post a Reply
cidnet since: Feb 11, 2008 from: Chicago	Re: Joining multiple Allowed Tables using an ACCESS database: Don't know if this will be of an assist or not, but this is how we handled building reports from multiple Allowed Tables without getting all sorts of duplicate records. ------ Here's our internal documentation showing how we do it.  It's what we provide as "Help" to our clients who use the ASP ReportWriter for ad hoc report/digital file creation in a browser based applications environment: Documentation starts here: ---------- DUPLICATE FIELD OPTIONS FOR MULTIPLE TABLE SELECTIONS In the beginning we made note of duplicate Field options.  Here we discuss how to link your Table Fields together to reduce errors in your report. You will notice at the bottom of the Field window (see above photo) an area labeled “Enter your tables’ relationship (Join fields)”.  In this area you are required to key in the following code that will allow your Fields to be joined for each Table they are showing in. [Table Name].[Field Name]=[Table Name].[Field Name] For more than one Table sharing more than one Field enter in the following code: [Table Name].[Field Name]=[Table Name].[Field Name] AND [Table Name].[Field Name] Keep using the AND command until you have linked all of the corresponding Fields. Let’s say you have multiple Fields in multiple Tables and you need to conjoin them, you would use the following code as many times as needed: [Table Name].[Field Name]=[Table Name].[Field Name] AND [Table Name].[Field Name]=[Table Name].[Field Name] In some cases you may find that all of the Field items for one particular Table may appear in other Tables that you have selected.  In this instance you would remove the smaller Table from your choices to avoid unnecessary coding and to save you time. --------- End Documentation.
Pages: (1)   [1]

search this forum: