sql - Select from table only with no records on the second table -

-

मेरे पास निम्न तालियां हैं

TABLE1 (ID_OWNER, NAME) < / p> 

 <कोड> 1, जॉन 1, एल्विस 1, माइकल 1, केल्विन   
  तालिका 2  (ID_OWNER, नाम)  < मेरी   
 मेरी शर्तों है:  
 केवल  टैब 1  से रिकॉर्ड वापस करें अगर रिकॉर्ड नहीं हैं  टैब 2   
  में एक ही स्वामी से, लेकिन अगर टैब्यूल में रिकॉर्ड हैं तो केवल TABLE_2 के अभिलेख पुनर्प्राप्त करें   
 I की कोशिश की  
  का चयन करें COALESCE (TB1.NAME, TB2.NAME) TABLE_2 TB2 बायाँ शामिल हों TABLE_1 TB1 से TB1.OWNER_ID = TB2.OWNER_ID न कि (TABLE_2 TB2_SUB कहां TB2_SUB.OWNER_ID से चयन मौजूद है 1 = TB1.OWNER_ID) कहां TB2.OWNER_ID = 1   
 लेकिन जब  TABLE_2  रिकॉर्ड क्वेरी रिकॉर्ड को पुनः प्राप्त नहीं है नहीं है।  < / Div> 
 
 
 आप अपना कोड overcomplicating हैं:  
  SELECT * F ROM तालिका 1 टी 1 जहां मौजूद नहीं है (चयन 1 से तालिका 2 जहां आईडी_OWNER = T1.ID_OWNER)

Comments

Post a Comment

Popular posts from this blog

java - ImportError: No module named py4j.java_gateway -

-
I'm trying to call the Python using the Java program py4j . I've been installing the plug-in Eclipse and test name Piidvi project. I'm trying to execute the following part of the code found on py4j webpage: Import from py4j.java_gateway to JavaGateway, java_import gateway = JavaGateway () jvm = gateway.jvm java_import (jvm, '' Org.eclipse Kkorkrisorsej. * ") Vrkspes_rut = Jvankresourkesplginkgetvrkspas (). GetRoot (Gateway .help (workspace_root, '* Projects *') project_names = [project.getName () (for projects workpace_root.getProjects))] print (Projekt_nam) But I There is an error in import. I have checked that the P4JJ is present in the Jar Eclipse plugin directory. Can anyone help please? I had to install the py4j application
Read more

python - Receiving "KeyError" after decoding json result from url -

-
I am new to Python I am trying to parse JSON result from a URL. Basically, I was using the following: response = urllib.request.urlopen (url) json_obj = json.load (response) It should be a stroke "str 'not' bytes' in the lines of a given" JSON object, so after searching on the StackoverView Flo, I decode the response in this way: F = urllib.request.urlopen (Url) charset = f.info (). Get_param ('charset', 'utf8') data = f.read () decoded = json.loads (data.decode (charset)) If I print "decode" I is as follows: { 'link': { 'summary data': 'https: // localhost / piwebapi / streams / p0_7qHaW4UHU-RlCaz8tpasAAQAAAAU0hJTExNQU42NDIwXFNJTlVTT0lE / summary' 'value': 'https: // localhost / Piwebapi / streams / P0_7qHaW4UHU-RlCaz8tpasAAQAAAAU0hJTExNQU42NDIwXFNJTlVTT0lE / price ',' InterpolatedData ':' https: // localhost / Piwebapi / streams / P0_7qHaW4UHU-RlCaz8tpasAAQAAAAU0hJTE...
Read more

c# - Get SelectedItem's Id in dynamically generated Menu -

-
I've created a menu dynamically. Here is the structure of my table: MenuItemId integer PrimaryKey MenuItemName nvarchar (50) ParentId integer NavigateURL nvarchar (500) Here is the C # code to get that data in the heirarchical structure: Private Zero GetMenuItems () {string cs = ConfigurationManager.ConnectionStrings ["DBCS"]. ConnectionString; SqlConnection con = new SqlConnection (CS); SqlDataAdapter da = New SqlDataAdapter ("spGetMenuData", con); Dataset ds = new dataset (); Da.Fill (DS); Forwarding (Datarov DR in Dtibles [0] .rao) {If (Dr. ["paradidied"]. Tostrings (). Trim () == "") {menu item = new menu item (); Item.Text = dr ["MenuItemName"] ToString (); Item.NavigateUrl = dr ["navigateUrl"] ToString (); ([Ds, drChild, item]] [GetChildItems (). ; }} Menu1.Items.Add (item); }}} Private Static Zero GetChildItems (DataSet DS, DataRow Dr, MenuItem Item) {MenuItem childItem = new MenuItem (); ChildItem.Te...
Read more