sql - how to add more rows to a existing table -

-

There are many columns in the table trainer for column only name Want to add more values ​​and get the value table from student The condition is that the student's name with tot_cred & gt; 100 is chosen My attempt is down but this error returns back. How can I solve this problem?

Update Instructor Set ID = (Choose ID from student where tot_cred & gt; '100');

The error is that

returned more than the subkey1 value. When subquery =,! =, & Lt;, & lt; =,>,> = Or when the subquery is used as an expression is not allowed. 

  update trainer set a.name = (student name name) Where id = a.id) where exists (where the student 'Select' id is = A.id and tot_cred & gt; '100');

Comments

Post a Comment

Popular posts from this blog

c# - SignalR: "Protocol error: Unknown transport." when navigating to hub -

-
Image
I am trying to use the ASP.NET signal for the first time - here's what I did: created a new web Has been added to the project and the following signal R packages: I have created the following category: [Hub-name ("chat")] Public class ChatHub: Hub {Public Zero Halo () {Clients.All.hello ( ); }} and the following startup configuration: public partial class startup {public zero configuration (IAppBuilder app) {configure (app); App.MapSignalR (); }} However, whenever I navigate localhost: (port) / api / signalr / chat I get the following error: Protocol error: Unknown transport. I am running a new browser and trying different people so remove it from the API / URL, and just use the localhost: (potter) / signaller / Chat
Read more

c# - WPF Expander overlay used in ItemsControl -

-
I've been searching for a while, but all the solutions I can only deal with parts of my issue. With an item control, which includes the expansion, upon expansion, the content of the extensioner should be shown as an item which is overlapping the other item in the item control and not taking them down. The following XAML-code is actually a big problem: the content of the expansion does not overlap other objects but is hidden behind them, I think it is because of ZIndex because the following in ItemsControl Items are added after expander content. I managed to set a single spreader's ZIndex 99 style triggers, but it appears to be very complicated and error-prone solution any thoughts? & lt; Window x: orbit = "wpfTest.MainWindow" xmlns = "http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns: x = "http://schemas.microsoft.com/winfx/2006/ Xaml "title =" main window "height =" 350 "width =" 525 "...
Read more

android - how to get distance of 2 beacons and make a condtion base on that distance -

-
I'm trying to figure out what I'm getting at the distance of 2 beacons with ID1D2 And ID3 is for beacon 1 and 2 beacon 2 ... but my code does not work :( ... I'm not good at programming and I do not know how to use most of the functions or methods of Altbikon Do ... can someone help me how to get the beacon distance and that distance of 2 beacons Create a suspension basis on .... Is there any sample code in doing this? Public ZeroKorangebackConision (collection & lieutenant; beacon> beacon, field area) {if ((Beacon. GetID 3 (.) Equal (identifier. PRSE ("1") and beacon.get diastans () This is the math for the distance var R = 6371; // km var Ï ?? 1 = toRad (Lat1); var Ï ?? 2 = toRad (lat2); Var Î ?? Ï ?? = ToRad ((lat2-lat1)); Var Î ?? Î »= toRad ((lon2-lon1)); Var a = Math.sin (Î ?? Ï ?? / 2) * Math.sin (Î ?? Ï? / 2) + math kos (Ï? 1) * math kos (Ï ?? 2) * math. Sin (Î ?? Î »/ 2) * monastery sin (Î ?? λ / 2); Var c = 2 * Math.atan2 (Math.sq...
Read more