SQL Server conditional join with differing results columns -

-

I have a new app for which I am trying to find out the data. And for my recreational vehicle ads, I think:

  • Ads - Includes AdID more general items like value
  • R.V.
  • Travel trailer - Includes travel trailer information

If an ad is in my "secondary" "If the tables are found in one of the ( traveltrailer or then one or the other condition is tied to AdID ). ) I have seen online questions like the following: 

  e Choose the name of the employee, organize (S.Store, O.Office) Leave the exit of the employee's place on the outer store S ... Left Outdoor Offices at o ...

The problem is a travel trailer and RV The tables will contain some special items that are not present in the other

  • RV

    • Using the code> approach, I can retrieve the motor column (if it is RV) and sometimes I can not (if it is a Trail Trailer) I can not understand how to do this.

    I can pass in a type ( RV or TravelTrailer ) and can run one of two separate questions depending on the type , But I just want to pass a AdID and I will get my information with that. I can also do two questions, using an ad information like AdID And then on the basis of that kind of a second that comes back from the ad table. I have to find out how to do this in a bridge if possible.

    Thank you!

    the way I am storing data 

      products (Product_id, product_type_id, product_attribute, att_value)      product_type_id reference id on product_type: (FK barrier)  > 
      product_types (id, name)  
     
     Ie you can have RV ID # and Motor Home ID ID # 2. 
     
     And where the product_attribute_id table on product ID is authorized: (FK barrier) 
     
      product_attributes (id, name))  
     
     Pass weight can be # 1, length id # 2, sleep capacity ID # 3, etc. 
     
     In this way, you can write some products in table X, some products in table Y, others will not be Z, etc. And you can write questions more normally. If your questions are constantly more complex, then it is usually related.

    Comments

    Post a Comment

    Popular posts from this blog

    java - org.apache.http.ProtocolException: Target host is not specified -

    -
    I have written a simple httprequest / response code and I am getting this error below: I used to type in my classpath httpclient, httpcore, common -Codecs and general logging. I am very new to Java and I do not know what's going on here. Please help me. code: import org.apache.http.client.HttpClient; Import org.apache.http.client.methods.HttpGet; Import org.apache.http.HttpResponse; Import org.apache.http.impl.client.HttpClientBuilder; Import org.apache.http.Header; Import org.apache.http.HttpHeaders; Public class UnshorteningUrl {public static zero main (string [] args throws exception {HttpGet request = zero; HTTP Client Client = HTTP ClientBuilder.credit (). Build (); Try {Request = New HTTP Gate ("trib.me/1lBFzSi"); HttpResponse httpResponse = client.execute (request); Header [] header = httpResponse.getHeaders (HttpHeaders.LOCATION); // Preconditions.checkState (headers.length == 1); String new url = header [0] .getValue (); System.out.println ("new url...
    Read more

    java - Gradle dependencies: compile project by relative path -

    -
    Is it possible to specify a dependency on another gradeal project in the granular (in android studios) outside the current project limits? For example, with a relative path like this: dependence {collection project ('../../ stdlib / dagger'}} MyApp (path / user / foo / workspace / mypad) The app (Path / User / Foo / Workspace / MyPass / App) And I have an Android Library Project with 3 subdomules: stdlib (path is / user / foo / Utilities (Path / User / Foo / Workspace / Stadlib / Utilis) http (Path / User / Foo / Workspace / Stadlib / HT) / Li> What I have to do is compile the Dagger, Util, http module in the MyApp project. The Stidelib Library module under heavy development And MyApp will grow in the form of Growth, so I do not want to push them into a Mewen repository. I am a little change. is likely to add another Gredle projects in some way? I will push the study library into the Maven repository after the source is in search of a temp...
    Read more

    ruby on rails - Object doesn't support #inspect when used with .include -

    -
    So I have participated in a glitch error that I do not even know how to debug. I am very new to the railing, so it has kicked my ass well when I use the .includes (school) seen by the student, it gives a blue box error, But when I look at any other model and .includes (school) , the school works just fine. class student & lt; ActiveRecord :: Base has has_many: relationships, foreign_key: "liker_id", dependent :: has_many: matches, foreign_key: "student_1_id", dependent :: deleted belong_to: school belong_to: conference belong_to: would_you_rather belong_to: home city belong_to: year is_to: Major and class school & lt; on the console activatecord :: Affiliate for the base: conference includes: respondent, class: "school", foreign_key: "rival_id" (e.g. For: School) Select SQL generated Select "School". * "School" from "school" "ID" IN (1) error message back NoMethodError: u...
    Read more