sql - Can't UNION on primary key -


so these 2 queries:

select * coursegrade;  select * lettergrades;

enter image description here

when union see lettergradeid has lettergrade:

select *      coursegrade     inner join lettergrades     on coursegrade.lettergradeid=lettergrades.lettergradeid;

i'm getting error saying 

invalid column name 'lettergradeid'.

can tell me going wrong?

you misspelled name cg.lettergradedid

select *  coursegrade cg inner join lettergrades lg on cg.lettergradedid=lg.lettergradeid;

Comments

Post a Comment

Popular posts from this blog

opencv - DataType<cv::detail::deriv_type>::depth what is it used for -

i wondering why line used in lucas kanade tracker in opencv: datatype<cv::detail::deriv_type>::depth can explain me? in opencv, depth of mat refers type of data contained in mat 's data buffer. represented integer values correspond given data type. these integers commonly abstracted appropriate macro definition (e.g. uchar data represented macro cv_8u ). cv::datatype type-traits class provides method obtain corresponding integer value without having memorize macro means data type. there few cases user code needs use datatype::depth . more common datatype::type . a simple example shows 1 possible use of datatype::depth : cv::mat uchar_data = cv::mat::ones(3, 3, cv_8uc1); cv::mat float_data; uchar_data.convertto(float_data, cv::datatype<float>::depth); // ^^ equivalently replaced // cv_32f macro float_data.at<float>(0,1) += 0.5f; std::cout << float_data << std::endl;...
Read more

Why can rails not find a route created by a helper? -

i created member route in rails 4: resources :line_items post 'decrement', on: :member end and gave matching method in line_items controller: def decrement @cart = current_cart @line_item = @cart.line_items.find_by_id(params[:id]) @line_item.decrement_quantity respond_to |format| if @line_item.save format.html { redirect_to shop_path, notice: 'line item updated.' } format.js {@current_item = @line_item} format.json { head :ok } else format.html { render action: "edit" } format.js {@current_item = @line_item} format.json { render json: @line_item.errors, status: :unprocessable_entity } end end end but when try make button: <%= button_to 'x', decrement_line_item_path(item) %> i error: no route matches [post] "/carts/25" what gives? your error message is: no route matches [post] "/carts/25" but expectin...
Read more

php - Redirect and hide target URL -

i want implement website youtube, these real urls of videos has hidden. when user comes in, , php webpage authenticate user, , redirect user real url of video. problem how can redirect url , hide real video url, or other ways prevent real url of videos exposed? i don't know if got point, looking this? $video_url = $user_is_authenticated ? $video_url : $authentication_url."?returnurl=".$video_url; echo "<a href='$video_url'>video title</a>"; this way, if user authenticated, send him real video url, otherwise login page seen instead. if don't want users see url can use session variables during authentication.
Read more