Conditional SQL statement using 2 tables

Ask a Question related to Dreamweaver AppDev, Design and Development.

  1. #1

    Default Conditional SQL statement using 2 tables

    Hello everyone,

    I am running into a bit of a snag, I have a column in one table that when the
    value is true it displays data from another table, could anyone help me in
    formulating my SELECT statement?? Thanks so much!

    TheRapidGroup Guest

  2. Similar Questions and Discussions

    1. Setting a string to a conditional statement?
      I want to allow users of my website to define there own custom queries using a form. The problem that i am running into is that cfset cannot handle...
    2. Advanced Conditional Statement and Disable Form
      Hi I have an advanced conditional statemet which basically shows an image when a recorset value = 0 Is it also possible to disable a form with an...
    3. Conditional statement not working
      This should be so easy, but it is not working. What should happen is that if $p=home in the url then it displays home.php and if $p does not...
    4. Conditional statement and param()
      Hello Below is a portion of a script that displays a table. The argument passed by param() determines the number of rows the table should...
    5. Conditional Statement
      I am trying to come up with the syntax for the expession in the conditional formating box. I want to turn the background yellow if the weekday =...
  3. #2

    Default Re: Conditional SQL statement using 2 tables

    If there is a direct link between these two tables, then why not join at the
    database level...you don't say which database you are using, but you could use
    a VIEW in SQL server or a QUERY in Access to join your tables, then you can
    simply use the View/Query for your recordset.

    Originally posted by: TheRapidGroup
    Hello everyone,

    I am running into a bit of a snag, I have a column in one table that when the
    value is true it displays data from another table, could anyone help me in
    formulating my SELECT statement?? Thanks so much!



    CarlGrint Guest

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139